SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002616s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531701 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531701 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80126,379814,741334,554199,430450,869265,70116,641089,295416,105195,147608,557245,690037,182007,673408,687830,45875,279958,782256,379636,184249,415819,927030,651424,845386,832058,872631,945965,515344,229961,292400,292196,396760,1002140,956960,277813,245105,117233,429176,470525,882980,666640,449348,469837,815742,1047069,908297,483380,74080,857721,872747,652905,280610,913076,524508,620934,24314,809740,78315,431005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]