SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40080 LIMIT 1 [ RunTime:0.001803s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40080 [ RunTime:0.005986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179713,890918,411131,264664,384540,118906,452514,110882,250706,965064,942154,419837,976919,674613,850536,163361,433382,313599,874262,408466,432624,482710,621434,264279,511354,16318,46764,263892,690613,467341,999762,262541,346659,20164,52819,540433,218021,386420,760760,156323,540503,220577,618047,317752,526215,887591,166865,778015,368532,287840,615133,93828,563019,404741,98399,13554,526040,835794,762066,585053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000770s ]