SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538180 LIMIT 1 [ RunTime:0.000729s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538180 [ RunTime:0.006142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017046,624564,47883,442059,47385,217141,79519,611928,877627,968258,201286,336673,606611,881877,505177,51601,703789,649276,704700,425222,635676,581034,410154,230308,892704,150204,850137,705512,363763,278901,540457,916821,1016675,130508,407572,625852,242802,772927,804560,477370,808394,877884,165749,238487,583334,786774,668672,631460,238012,331818,283419,512721,468791,265632,124966,759572,427006,861327,58469,573373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]