SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 949407 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 949407 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410563,454910,954971,293841,135774,308018,167786,588027,971743,605573,593517,160674,951970,205486,301451,635736,729425,500024,700532,580491,696982,273701,348937,406645,745619,237191,62442,791193,821792,710658,294277,515574,319046,736709,994738,795992,6956,976008,504778,137314,887073,900035,1012845,23038,254940,561769,1045926,944584,942689,102101,236053,749923,301752,127855,556774,644400,115491,1024821,68588,236295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 949407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 949407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]