SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294611 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294611 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848185,546546,1018418,3140,368537,1026013,580422,531377,453956,598483,249186,499921,305700,173513,444160,389058,889592,635525,8495,10767,893940,402974,63854,492314,550103,628516,112822,58709,545372,516640,1010466,574999,589725,202503,655142,255384,377204,286382,208395,391752,336450,121157,50776,951001,874231,949977,701848,122934,932252,746544,1042066,828015,547976,340615,916680,717264,266702,109833,357168,304567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]