SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450086 LIMIT 1 [ RunTime:0.000678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450086 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542328,840423,919915,1036098,211940,764549,341317,432770,40299,1002215,315166,506424,849911,354898,1011112,798683,302713,302925,524541,1044930,667536,181063,653366,735742,211437,758461,814363,80963,836667,588110,842074,463394,266766,764311,564009,568358,514932,660358,571287,888283,272997,499911,753318,868053,968360,512914,692521,601040,606948,111121,692476,773001,1030195,1048237,55803,298864,111945,910240,564190,34287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]