SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429711 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429711 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293253,336801,836997,489861,420305,1032489,594139,264799,909667,99495,1002000,269021,238687,605991,625225,138649,86175,574690,36945,814872,532024,470079,674201,810038,962986,866702,49013,626762,112183,127349,701631,631089,490218,852149,503532,359814,289727,738887,85577,480426,534182,382766,136558,802408,431890,1018036,988960,551641,78667,519224,671996,179243,264714,1008671,741334,798681,367669,855395,725597,52126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]