SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505560 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505560 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372649,479825,741912,876089,226595,265916,770896,126762,210300,723010,35232,939364,771506,126400,801757,309221,472572,440464,944943,400372,457935,924471,93938,155730,321339,229005,750897,516292,759288,594296,775920,407315,750169,816926,65864,356231,433817,889817,929269,385116,695322,1002389,400240,534573,725493,744841,901067,230139,957622,348918,828704,881481,677815,551914,806477,366881,958789,335883,143509,628422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001783s ]