SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 651038 LIMIT 1 [ RunTime:0.002550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 651038 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649387,584632,65413,512263,741142,735772,804257,948868,299080,80921,365242,318797,57229,205863,248396,417095,609316,430331,835097,225720,447591,679467,683008,1013884,998085,926111,219889,639126,674224,132468,731261,285645,689495,1037610,609322,769522,705030,327979,840595,295127,327229,484703,644181,710456,626943,492448,25171,848548,661278,295531,181862,930755,690105,55350,1028306,670101,762831,807919,560218,994861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 651038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 651038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001787s ]