SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005648s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478513 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478513 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366889,468024,842851,192762,620354,472073,746349,294842,328639,121761,401841,879103,952220,1040349,205876,695463,780293,852925,182952,655016,5726,856493,258487,442962,1043298,1034029,374210,734125,704950,374190,370837,481502,123004,608573,1005997,288111,496709,91854,389878,482786,510632,289439,97507,809538,678017,258824,34553,941510,213398,772787,999009,523546,964989,466441,216712,914078,670511,95434,106353,358550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]