SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001778s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562746 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562746 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155838,391056,781238,904265,252675,659030,455668,439690,390468,980064,226630,689805,293705,928379,115677,891988,421728,410592,417255,1034890,471924,834436,374280,845283,273261,719824,217778,1007036,806953,923222,589512,803532,421424,507311,1018337,805179,451747,380544,37848,313601,863523,680578,872420,556854,315948,583623,110604,391242,936723,191891,184344,416477,374532,749212,1011413,891133,595456,530668,501037,514298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]