SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30201 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30201 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028552,345211,630584,333332,534567,735114,3991,878483,393175,277994,745497,920933,824418,712245,206795,532043,144684,349943,938775,7036,861795,52312,58009,623779,123323,789626,89075,598762,475135,702775,497287,626128,457201,648216,882361,396329,1009511,657432,998749,700680,663160,901555,816969,646427,750836,428074,716610,541534,664536,552277,839216,701464,856819,18543,799093,532414,67725,561543,967098,592775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]