SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337922 LIMIT 1 [ RunTime:0.001096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337922 [ RunTime:0.004232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415291,454208,407002,432457,1001892,641569,669018,102960,523079,289956,1012165,950197,273122,235895,526599,266368,291557,428945,1013561,539044,96495,25851,36436,689067,1022278,839553,437468,673303,1010066,518336,920453,241875,127804,365155,700047,396741,743985,308570,174254,711504,491079,400286,663994,579656,232544,961560,1008224,755164,942317,564858,657265,60559,456885,915065,241855,360286,738897,486511,1029053,874345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]