SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541693 LIMIT 1 [ RunTime:0.003673s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541693 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685891,994282,111658,89306,779524,112693,959248,202450,170320,235259,780097,969734,214071,1019668,609143,918189,131665,814542,365574,826312,275766,593477,921530,181288,834369,366332,86688,715584,755754,376494,90813,996932,341533,368142,626044,525298,1007179,952140,206642,570599,596552,444376,976830,703029,370621,1038343,358063,316687,325806,677355,791677,960761,366431,1025969,102858,90727,522052,491390,892373,287501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002751s ]