SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003756s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331310 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331310 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021780,375343,507156,554660,787882,555487,862085,739802,173544,416444,408654,381020,23550,832634,826090,453756,1012555,323079,970317,561455,152667,419709,314577,742395,248205,142198,14026,268506,832149,152835,86441,707207,619278,687882,683691,421933,366465,256745,66770,1048650,145420,1002918,652028,850232,395575,1014410,390479,480190,677513,1045255,950453,1038009,341429,778841,222787,425864,505756,543943,570344,521927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]