SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511871 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511871 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197744,440433,391520,841022,459652,482650,6969,631205,596634,531050,157021,833919,49012,1035555,836194,825564,198103,523921,513555,741523,703453,483643,271096,524693,644601,536783,978410,70146,732745,490168,321558,379433,580871,497317,259553,435433,945439,1026095,113617,271949,777182,736672,931063,641532,12366,351305,837299,848512,731923,786690,586448,528044,358783,162959,235795,448097,591537,614269,74401,519474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002830s ]