SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422316 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422316 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54744,974438,351362,240989,676227,789581,73388,490612,18534,1040036,750477,410228,286913,19131,660730,145352,746216,737792,482314,415639,612615,704442,570602,733839,321102,117953,902295,773492,158409,573990,927120,76861,228101,13079,34071,563419,538851,1039539,753396,891979,932286,708074,849929,373699,71057,454567,342063,673461,346397,815879,607852,126178,659686,302071,439932,832611,749199,420524,904159,783241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]