SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 156043 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 156043 [ RunTime:0.005287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513945,524116,884739,37501,156032,49005,765298,42952,886832,538766,822017,1010157,758281,215323,914547,90632,204273,959444,416608,1010651,687616,991255,621811,722438,422257,714367,49611,390904,527569,609079,130068,142846,994211,915590,1023789,285989,929778,785277,664905,779242,578887,775549,9354,722813,632907,956115,195353,503977,147967,380877,30610,845122,324525,319859,264210,934257,782394,1012961,888108,9757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 156043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 156043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]