SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002640s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310685 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310685 [ RunTime:0.002627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288169,29198,344848,339935,145142,478850,483061,156569,434899,94774,31208,856379,812007,700479,48811,3059,721442,197790,299669,936182,821945,650191,807261,716711,422365,50064,896980,418718,96500,83197,703901,964070,108901,324696,991583,40155,946569,528700,948663,486649,346337,674111,464611,15945,919734,345341,327351,194350,349557,316420,831177,531113,400028,167069,571750,406035,14070,147441,532843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]