SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020010 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020010 [ RunTime:0.004344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294990,261841,404292,248067,643401,840617,754147,628815,893434,812952,922851,137653,419398,265921,908870,678297,932481,956929,604532,663299,587537,230256,739804,480203,394887,468248,999736,136378,704928,290350,796831,566029,1034877,923754,994009,662152,171996,615548,12890,182977,1001192,996688,633988,803106,857848,220147,12483,969689,514717,434010,794788,639578,377938,122949,800208,588154,471538,251976,1003914,49224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]