SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354809 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354809 [ RunTime:0.002914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019569,448697,87227,407014,176289,615287,755392,285192,780479,294692,423512,913636,217169,728160,926109,194609,81578,3289,964525,848990,346171,667040,953714,792501,523795,971800,313299,333265,622417,21863,204870,961843,946249,400651,211487,144774,144798,17482,496623,879263,413128,922111,1023210,770734,781702,295488,699489,110102,115340,91286,750972,51646,131749,460023,510247,546800,583041,720028,602392,1028241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001955s ]