SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001957s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554209 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554209 [ RunTime:0.003311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18026,159823,258436,554164,309034,771908,801849,381814,736361,608959,215062,723444,420082,932870,214335,578978,680075,664114,370511,402395,639249,325240,319018,486747,59149,486706,576992,625494,834767,287784,1014999,862666,557688,499359,739144,594814,1027759,97917,249733,461197,371538,458073,412897,223415,578695,650709,109823,1028421,76142,506559,544057,59462,517355,862255,157414,860412,284116,64643,871234,301329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005351s ]