SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014606 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014606 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267991,97525,545490,147199,545470,712054,351493,113574,91310,364206,153807,595012,1033888,550147,280712,944599,959141,277188,272126,513542,122714,805465,740070,84621,347335,21414,859507,287910,540230,153310,64833,15038,991822,826921,730735,211116,1024537,249087,638866,866124,604703,572700,342148,141634,608187,400539,711228,929396,844601,366242,181327,843178,758312,359040,34265,640215,486749,820920,610508,417111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]