SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404143 LIMIT 1 [ RunTime:0.002716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404143 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591734,742366,805745,650637,123419,459391,475870,462787,327534,334895,568474,224594,774872,666944,888546,801992,433518,543932,188511,750818,616782,128259,122127,236717,822809,842865,760580,350275,644484,86137,621930,891225,261335,198589,697387,726985,575670,59412,1005119,1031140,1044000,65220,34753,315723,900067,415373,241298,498135,877997,819008,546085,194303,98400,130035,408178,1032573,438816,683158,610312,915566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]