SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003741s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20131 LIMIT 1 [ RunTime:0.004947s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20131 [ RunTime:0.007612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266658,20855,296422,1018,579251,224492,99337,893281,793208,981436,1047877,954353,909196,57552,941721,387132,231772,191854,152976,693951,518618,952137,872206,148922,404084,650343,393846,1019815,183758,306461,530122,351953,783502,656497,390391,438010,629374,220518,507737,895456,668796,304227,504110,653003,893419,1046601,133530,679827,772540,940799,992042,325373,249407,1020871,300651,191592,208965,131178,125601,386935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003107s ]