SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470831 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470831 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939981,113652,709794,57354,224199,137889,1034677,985579,850941,829647,155268,339814,964205,294939,1005505,78504,717694,616905,692900,282862,411828,19986,1044670,72694,139679,1030390,644402,21178,71562,880216,547497,94591,447966,514479,876009,833429,753201,136474,290928,933505,59553,786989,949033,826053,712114,90779,998246,251797,881861,459354,124971,743680,88281,643144,446061,708664,901749,571110,995537,772029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]