SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506265 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506265 [ RunTime:0.002732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025369,967254,440179,893122,751831,830844,98283,594057,199795,910329,1021555,664392,65801,291519,996698,684710,233550,430760,368174,1012303,803606,566731,446864,824505,275845,1044813,736953,228729,1017704,790475,628839,194286,41228,751936,963883,9203,845294,212588,870357,270588,681372,659422,454574,347862,69447,471136,751433,626042,372919,799871,508828,505015,952916,959499,308044,910206,440581,509483,282709,901430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506265 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506265 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]