SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34765 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34765 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136959,695870,861518,753696,765528,867783,497460,149771,587352,146043,744398,979315,972791,1013449,813374,540921,1004636,598879,857857,715120,308616,151484,971754,82372,686422,714674,277386,775110,515717,94070,495123,193227,997265,211563,105180,63289,118458,137402,362687,496044,797527,354638,946439,1034519,35379,360207,64828,554405,640637,557124,476691,211431,304163,469720,444284,862155,986836,897021,484901,989854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001865s ]