SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42677 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42677 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613523,172856,406672,274250,323709,24689,273828,441209,231295,830745,254407,269963,16556,935781,1047657,445652,271514,143033,71513,684271,32523,427813,476088,263046,183585,710206,100509,277489,228910,342053,621981,905136,645176,941529,851947,879796,1023281,998402,498716,855714,183928,362755,54457,90793,21980,72313,724095,4673,810484,972143,303242,29917,482539,117117,516003,179522,879540,134831,186965,387412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42677 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42677 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]