SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035540 LIMIT 1 [ RunTime:0.000941s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035540 [ RunTime:0.003146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861380,599977,455192,922658,114259,421332,688417,737085,929850,556647,472271,551540,1002867,843838,765772,317392,1000198,196218,576762,666819,493707,211518,1016782,789517,167337,719105,390804,700798,767513,423346,344765,482594,769392,881620,15459,568805,947781,1022499,498900,690194,42407,317326,961950,718642,79769,363883,1046489,732958,517057,953276,984064,1030641,501855,203357,1043323,238152,851580,491635,548598,807139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]