SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405809 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405809 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838925,229138,929253,575409,614983,447344,713692,217314,591464,538775,346267,320997,768923,301341,12988,624686,628556,660866,247287,26704,142571,85934,479521,817928,204669,550783,531790,669015,251016,526571,159457,500939,145532,232231,953188,186691,441788,739380,606547,848638,669225,927609,136357,701673,806160,780442,262223,226111,1033366,264412,681255,163922,531541,278438,213526,299566,349146,61038,524989,513009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]