SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104278 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104278 [ RunTime:0.003225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235954,24368,207242,1018740,417776,304467,967048,279282,523765,494568,39252,176544,164283,48531,242503,224603,973506,368455,931028,362903,1048638,64830,8470,861988,427730,467039,938174,320434,106400,702628,455839,377218,620831,32260,910909,1011688,536400,1017879,770916,372569,232511,643336,346292,149874,550810,208836,16624,884368,268834,168971,648557,445471,566187,471624,562612,722050,966030,392018,207599,696465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104278 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104278 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]