SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314913 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314913 [ RunTime:0.002296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182883,356358,228562,15286,562601,983168,455327,322362,186952,57659,927039,813913,6998,791715,719344,257797,514279,202506,141722,724737,982438,1001326,264666,384375,137078,128457,35926,223419,335164,721796,747840,764688,540484,180199,515658,256314,875527,680744,53145,706592,606305,509902,991019,637127,240697,284408,698290,81145,708071,858948,347257,16942,975177,884044,183055,290114,451625,859768,231458,689179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]