SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034644 LIMIT 1 [ RunTime:0.001872s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034644 [ RunTime:0.004244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129096,4576,979955,254900,195776,677475,154828,880649,922398,99147,874963,764113,539691,71921,753825,751157,987567,555429,898138,336262,50974,261386,675577,641806,461118,598190,140766,273275,600990,149082,552261,106007,944132,276088,799320,545713,140003,740332,503284,420353,506119,882888,931788,327262,299487,301779,76198,906423,598472,245648,636748,891377,715293,304211,722717,761853,690026,27220,691749,1038235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]