SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026607 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026607 [ RunTime:0.003353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183513,143148,946374,861228,498856,672811,978124,474704,472718,936770,114067,721472,482857,197240,689849,726902,33482,195444,394822,577522,482777,125220,69898,783000,1011241,183663,127074,557192,848811,771948,1037902,963079,680562,221368,208701,343320,12220,703797,779741,961514,241095,463635,315600,248420,479306,380981,1037079,492795,564392,462763,193651,967400,909241,322582,836497,857459,241767,944318,627862,487412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]