SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346593 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346593 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206829,963988,713335,936287,783649,912430,8416,520284,344584,451110,655092,813718,836299,205300,558371,296241,996456,163514,204207,1037673,31983,50158,486650,633330,196423,533175,191206,335647,590257,304239,641908,542604,773553,377087,812073,59884,363600,872409,918183,933865,337799,911759,149606,746619,236312,310106,937112,559933,230898,361608,507790,561588,788519,96974,924527,585022,557833,133868,186308,440214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]