SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037138 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037138 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1383,332710,1000305,699765,367320,539795,530269,327710,290028,153662,526891,1032541,454647,95190,299601,231084,786254,849321,604188,131510,912066,777800,147021,454512,49481,730896,335561,900102,853467,412877,323435,390340,930431,769994,530307,518271,158211,94973,728234,829960,941374,613904,436254,497279,915673,521617,569957,611792,24924,866274,66347,966722,583353,849265,158131,476983,472119,232351,428552,91712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]