SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 155580 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 155580 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198032,944747,746005,1046617,881785,26139,576209,446037,755421,53083,1039224,318850,102561,361071,209515,19755,703896,594259,900952,900480,308469,930029,428693,633093,534348,318119,535886,279540,238951,677795,228138,342141,864539,256752,902561,322648,403245,949646,348102,518320,150477,499819,79836,837106,474392,662429,558543,684092,609639,911618,681839,165816,924272,483974,488476,630118,716807,439613,941300,263397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 155580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 155580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]