SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332008 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332008 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277825,1038688,618215,603216,602608,1013855,334102,295352,644041,770260,763975,55652,185607,278534,347207,1035065,1011984,91877,170238,1036830,304221,557394,729344,1039728,417517,956312,201468,1008319,413515,87448,644368,420042,983422,904263,209475,665676,983608,693791,753297,117486,110387,291672,490343,367864,652324,726374,147910,723275,284309,95771,644671,452586,210212,871992,665117,365270,828425,858662,945469,688960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001815s ]