SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390542 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390542 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964840,271477,372633,670728,170278,826490,1020062,668631,634346,138249,258950,1021263,437045,69095,562461,346501,752805,440131,881314,570873,797372,1015558,1047788,218300,483628,471803,264068,345369,749927,1040610,639214,122711,959208,875055,358566,839540,534808,123473,1006722,31708,1033175,427442,687503,751837,665708,923956,231805,408501,248318,479386,874559,521430,387018,50148,5832,465985,973912,36430,605055,458263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]