SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402988 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402988 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85886,202637,832851,618139,41843,1012850,522312,768005,509897,211322,938616,174689,821657,433835,111000,812906,1006418,854091,57751,775489,413664,830207,332118,604456,873663,1045927,382767,96589,1037836,772966,948128,407040,317755,183735,466793,181338,227001,63026,311459,646284,259257,447748,992640,13519,249091,134010,732391,771359,77447,395621,392117,983979,860864,848215,288367,789883,850326,428456,1046604,504451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]