SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539836 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539836 [ RunTime:0.002836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422087,409026,306862,324568,531746,365862,600748,912541,662806,404634,123950,818754,966988,944111,203810,574314,717919,801012,811092,554787,685070,468627,121872,521907,970012,479112,969626,507825,490752,948673,233362,803805,45972,1042773,868127,573077,340688,373619,87589,452614,52961,89873,1015937,862889,165125,882915,226795,148387,114421,384949,614234,599765,430174,459221,354874,955594,438941,427525,13109,589312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001225s ]