SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502610 LIMIT 1 [ RunTime:0.001015s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502610 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783735,675606,836281,1020130,279447,288808,972911,325884,172085,400735,720412,272653,272230,594224,505027,117342,43058,631075,191559,959001,600891,1014773,847213,414991,1022316,781248,1022900,191021,236852,684128,18300,1046923,200821,265372,153168,777704,537263,421350,607469,885588,260186,941393,919895,144594,157627,815522,802900,1004189,597915,342915,529902,391788,467611,515165,1033101,626097,542373,492350,517031,238815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]