SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505422 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505422 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999309,109982,446880,314248,699934,488301,110410,717008,758720,358221,808620,462896,624832,206059,870759,477689,1013092,799860,290373,576932,465482,71454,813634,343343,205127,107318,275567,392339,725086,8649,414941,863336,259974,425647,420344,734240,37869,1040506,799148,289925,666998,687717,1041700,85259,1047110,869664,983482,16295,618722,499393,596990,770183,171672,439984,54841,83603,2638,1008317,200092,136864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]