SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035280 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035280 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687242,687744,163670,519269,469556,687949,844828,85992,828220,490842,308872,971616,70859,742431,769923,916921,453075,92569,974091,463902,1024360,793037,334920,958271,896458,445292,754279,177999,1029042,842188,832586,1046293,836795,284958,822611,106376,978727,824730,402234,174675,131862,462286,440472,298078,188078,1011055,1004213,746338,470122,731003,895391,988290,327774,829962,662831,331784,1047023,159106,77348,285002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001793s ]