SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502695 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502695 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839560,968701,550673,837805,358801,313400,589209,738691,626828,555004,363501,584140,956541,207291,618890,976585,698795,463141,973641,30275,693366,561213,497830,351958,429786,997018,142487,655418,402430,70168,500737,323219,936984,217485,122235,1004978,345427,598484,495292,409686,584501,939716,3878,628257,752209,603289,401176,282723,3500,721484,904745,417009,829208,597280,677866,994089,848128,124410,12872,174754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502695 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502695 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000359s ]