SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534390 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534390 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478933,63538,544969,227184,118674,484242,90350,831148,155470,113785,298776,94371,420356,181702,658528,120658,581100,359436,832760,529992,231343,733302,874693,25467,705821,1008264,749958,205205,342033,547149,893242,102460,460902,883764,454897,837495,549435,671536,675227,1035442,1025792,381126,756957,22135,98855,13318,801148,474066,569452,677490,183352,985531,44832,486702,940192,307723,895003,697098,224802,220391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002077s ]