SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437822 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437822 [ RunTime:0.003556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806003,593079,765781,437913,255070,548691,544575,21940,995047,444360,276086,524024,554491,35484,900824,266561,50235,1024137,475483,745428,784638,612210,435616,872104,43336,333061,670803,584262,490860,605965,129612,684991,396440,329787,5609,168657,256119,1020184,516121,896856,944145,392917,70061,175943,638396,965919,609421,333807,151911,455304,285709,652489,803961,302570,430313,612529,753122,253538,378746,439581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]