SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486040 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486040 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232608,736375,588281,382805,150138,409993,260361,60720,451982,208062,961331,804974,753162,155087,665490,720691,29643,153225,493416,953426,141545,247398,340483,953294,882709,1000524,409554,185983,449631,1014614,961957,98192,1025883,451021,105430,892108,916297,61858,768089,541426,671821,356350,1026114,783433,613993,624547,148698,530289,757410,458766,477243,877343,473449,144787,312289,166700,460580,601698,130863,50991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]