SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438986 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438986 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409829,1010407,463617,256202,194362,932122,324250,869414,1027178,620073,915282,301604,1044882,425657,698434,13026,879038,579953,849057,232703,522557,652844,685843,996389,310293,322175,9863,558589,290781,112221,95790,662553,957097,948819,798593,611742,226358,910746,609252,702319,377003,154170,128563,1015602,822512,291353,339645,712298,267786,270534,458853,437466,1009622,292174,753753,1040906,711946,604494,262865,953571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]