SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403310 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403310 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533568,335704,427345,444198,645556,877785,914449,976336,754196,161902,82923,491835,62498,660748,610802,366567,724640,994178,244699,648046,438910,871033,52147,509219,714321,264053,246955,1000473,956638,193992,31033,707600,1030353,715484,466136,581186,564006,917807,1010810,489479,35979,643924,39616,852959,874210,689302,815894,64054,450220,886142,480755,592125,246599,193143,1044043,195490,522699,101400,636644,1048069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]