SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427132 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427132 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211559,691995,519587,1013463,359878,806841,535144,624597,339552,72221,694575,171301,992589,999965,753378,244812,999934,98365,70359,656342,61533,893225,658450,57849,538204,561441,544275,958052,963929,76861,244232,926784,756975,725394,989898,252891,1011960,934652,759714,927385,221686,337480,272137,154213,762926,367733,44838,197815,254836,311680,281196,952762,324912,154190,272532,651280,116797,1041283,55683,606027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]