SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495017 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495017 [ RunTime:0.002763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193818,381139,863968,927908,1047676,213873,703287,774728,334326,633760,703912,475091,121049,951251,314061,123841,822625,810848,488000,204432,114289,533597,486754,957377,485382,322449,649308,753285,78606,630645,291640,1040278,876365,720602,46705,674090,808623,535701,46807,34164,841261,992213,817787,460943,68250,572723,296307,266141,9649,451753,860769,221337,191366,225908,743174,113390,462213,560952,124265,875205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]