SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393799 LIMIT 1 [ RunTime:0.001394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393799 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585073,544075,661496,767657,73450,1998,569835,846204,203572,28713,466817,116090,9799,494365,533135,324340,300130,845035,657568,446270,441627,746930,445837,778186,784064,1021653,311512,430141,747301,340230,712081,421662,143984,738576,977649,533265,943925,87434,532846,710592,256076,144986,820819,501869,484915,619777,365802,189416,229473,1043308,470480,168550,961168,899414,62572,137718,751516,681761,397066,552747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]