SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 373413 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 373413 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766890,1006629,1035111,917592,821571,806240,150547,961831,158189,503362,361822,994492,835868,963557,51573,887527,383025,504455,597864,649338,128711,443957,63871,974077,293645,861037,450284,799551,909633,353984,887520,769137,325821,868308,150704,19702,869159,178318,319372,833437,1011028,465676,872674,267637,857189,883675,686934,400755,872059,535357,988395,751381,643972,161948,625503,941280,842224,234928,452841,677437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 373413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 373413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000909s ]