SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501351 LIMIT 1 [ RunTime:0.001129s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501351 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116723,835635,741255,988060,441085,192729,117747,255056,928086,890747,395440,658368,955412,491228,811664,51757,556227,347721,577419,773283,57194,32583,667124,762098,426946,299460,883826,1035366,755793,54621,732142,139689,912840,447636,808759,140739,211201,697275,118167,987213,732806,489512,1040851,148727,25725,176665,523208,298305,782730,736410,153658,18218,78114,787551,551478,280982,554581,239912,915325,1037650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.033134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002687s ]