SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513513 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513513 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482915,40580,865503,82180,847037,169494,710451,259495,1036164,121837,162414,65124,696863,799330,419760,615432,270485,316,868,488755,925780,400615,235895,341869,478978,746013,758743,662556,395506,466591,571963,619674,681069,796973,454825,836535,559240,951624,991366,641498,189017,183330,678474,958399,755,112395,800415,430540,403734,1034654,278747,271422,334339,406488,894102,837812,330749,343426,759118,750372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001375s ]