SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467906 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467906 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48215,466266,475846,672016,1017619,61780,250743,252607,133931,41261,478933,873660,820377,158629,525976,586242,471222,274767,307530,833933,946521,999345,280897,55817,379955,543864,265960,849786,520725,673223,384274,790162,668918,1035058,46999,714240,817912,810098,1033709,466119,249403,498301,851809,514304,228523,202631,446224,979899,544844,293050,129518,490196,736619,108540,855988,622291,173094,109843,27517,373346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]