SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400221 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400221 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169997,993891,1003984,284160,408735,937414,297479,401128,629407,476614,703701,460886,1009945,365606,794408,179956,50790,959510,191846,371374,946666,829358,952413,299352,318862,839567,659944,557,524980,423199,477308,295395,45843,216,611336,905715,471426,221579,97315,933085,167031,572364,745949,390312,201890,731941,896248,379590,1040950,58129,550339,371883,495893,350314,655335,1026953,560620,74403,677660,376065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]