SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403861 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403861 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622254,820438,707332,28199,633317,1029699,392457,554599,676467,502454,907678,16316,568238,924425,539344,314516,298209,1022146,58981,628589,267689,415264,813610,258068,1008577,830770,1039582,119312,339996,73778,135864,588218,822504,687219,860377,94310,3947,165618,1016970,740633,656403,180920,759665,717395,57983,797689,492115,962298,500068,910160,92663,49743,124312,232206,890701,982924,726597,72535,872581,268370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]