SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420284 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420284 [ RunTime:0.003590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89248,442998,77895,618819,599044,473574,957187,392305,933494,377210,718875,9884,140301,606132,574975,599373,9572,292532,784034,461240,262783,645138,791531,485100,14054,1042944,165759,270213,944954,317307,938764,317167,633895,596596,695156,435129,727668,849651,102915,539729,273056,847557,824385,968230,928250,352443,833800,691144,536564,514207,447490,976814,364561,807750,412895,348155,371141,147163,164598,687445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]